home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Fritz: All Fritz
/
All Fritz.zip
/
All Fritz
/
FILES
/
DATAUTIL
/
DPERFECT.LZH
/
DPERF17.EXE
/
DPERFECT.DOC
< prev
next >
Wrap
Text File
|
1992-04-22
|
51KB
|
1,181 lines
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
dPerfect Merge
Convert data base files to Word Perfect secondary merge files
Copyright 1992 Newdorf Research
All Rights Reserved
P.O. Box 2309
Rancho Santa Fe, CA 92067
Barbara J. Feldman
CompuServe ID: 73170,216
VOICE: (619) 942-0688 (ask for Barbara)
FAX: (619) 942-9387
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
dPerfect Merge is a copyrighted SHAREWARE program. You are free to try
this program for thirty days and to distribute it freely to your friends
and associates. Please distribute the self-extracting archive file instead
of the individual files. If you use this program beyond the thirty day
trial, you are required to register your copy. If you include any part of
dPerfect Merge in a system for resale, you must register each copy of
dPerfect Merge. See Page 16 for registration details.
The complete dPerfect Merge package contains the following:
dPERFECT.EXE -- Interactive translation utility (Try this first!)
dPERFECT.DOC -- This documentation file
dPERF$$$.DBF -- Required configuration file
dPERFBV.EXE -- Batch translation utility (dPerfect BV)
dP_BTEST.BAT -- Sample batch program using dPerfect BV
dPERFECT.OBJ -- Clipper function for inclusion in Clipper programs
dP_CLIPP.PRG -- Sample Clipper program using dPERFECT.OBJ
dP_REGIS.TER -- Registration form
dP_READ.ME -- A list of files in the archive
This program is produced by a member of the Association of Shareware
Professionals (ASP). ASP wants to make sure that the shareware principle
works for you. If you are unable to resolve a shareware-related problem
with an ASP member by contacting the member directly, ASP may be able to
help. The ASP Ombudsman can help you resolve a dispute or problem with an
ASP member, but does not provide technical support for members' products.
Please write to the ASP Ombudsman at 545 Grover Road, Muskegon, MI 49442
or send a CompuServe message via CompuServe Mail to ASP Ombudsman 70007,3536.
Note: dBase is a registered trademark of Ashton-Tate. Word Perfect is a
registered trademark of WordPerfect Corp. Clipper is a registered trademark
of Nantucket Corp. FoxBase and FoxPro are registered trademarks of Fox
Software.
Page i
Table of Contents
CREATE MERGE FILE . . . . . . . . . . . . . . . . . . . . . . . . . Page 1
"Enter path and filename of source data base file:". . . . . . Page 1
"Enter key expression to create index:". . . . . . . . . . . . Page 1
"OR enter path and filename of existing index:" . . . . . . Page 1
"Enter path and filename of Word Perfect secondary merge file to
be created:". . . . . . . . . . . . . . . . . . . . . . . Page 2
"Enter record selection criteria:" . . . . . . . . . . . . . . Page 2
"There are ___ records that meet your criteria". . . . . . . . Page 2
"Mark fields to be included with the PLUS key:". . . . . . . . Page 3
"Want to save these parameters as a setup file? [Y/N]" . . . . Page 3
"Do you want to print a summary sheet? [Y/N]". . . . . . . . . Page 3
CHANGE dPERFECT MERGE CONFIGURATION . . . . . . . . . . . . . . . . Page 4
Default Configuration Parameters . . . . . . . . . . . . . . . Page 4
"Word Perfect version:". . . . . . . . . . . . . . . . . . . . Page 4
"Date format:" . . . . . . . . . . . . . . . . . . . . . . . . Page 4
"Temporary delimiter:" . . . . . . . . . . . . . . . . . . . . Page 4
"Logical values:". . . . . . . . . . . . . . . . . . . . . . . Page 4
"Color monitor:" . . . . . . . . . . . . . . . . . . . . . . . Page 4
"European character set:". . . . . . . . . . . . . . . . . . . Page 5
Use of the Configuration File. . . . . . . . . . . . . . . . . Page 5
REGISTRATION INFO . . . . . . . . . . . . . . . . . . . . . . . . . Page 6
"Name of Registered Owner:". . . . . . . . . . . . . . . . . . Page 6
"Registration Key:". . . . . . . . . . . . . . . . . . . . . . Page 6
CompuServe Offer . . . . . . . . . . . . . . . . . . . . . . . Page 6
USING dPERFECT MERGE. . . . . . . . . . . . . . . . . . . . . . . . Page 7
Help Screens . . . . . . . . . . . . . . . . . . . . . . . . . Page 7
Using Setup Files. . . . . . . . . . . . . . . . . . . . . . . Page 7
Versions of Word Perfect Supported . . . . . . . . . . . . . . Page 7
Using Word Perfect Merge Files . . . . . . . . . . . . . . . . Page 7
Network Capabilities of dPerfect Merge . . . . . . . . . . . . Page 8
Use of the Tilde (~) Character . . . . . . . . . . . . . . . . Page 8
Working Disk Space Required. . . . . . . . . . . . . . . . . . Page 8
Temporary Working Files. . . . . . . . . . . . . . . . . . . . Page 8
Minimum DOS Configuration Required . . . . . . . . . . . . . . Page 9
Index Key Expressions. . . . . . . . . . . . . . . . . . . . Page 10
Record Selection Criteria. . . . . . . . . . . . . . . . . . Page 11
BATCH VERSION OF dPERFECT MERGE . . . . . . . . . . . . . . . . . Page 12
Using the Batch Version of dPerfect (dPERFBV.EXE). . . . . . Page 12
Sample Batch File (dP_BTEST.BAT) . . . . . . . . . . . . . . Page 12
CLIPPER FUNCTION dPERFECT() . . . . . . . . . . . . . . . . . . . Page 13
dPerfect() Syntax. . . . . . . . . . . . . . . . . . . . . . Page 13
dPerfect() Arguments . . . . . . . . . . . . . . . . . . . . Page 13
dPerfect() Return Value. . . . . . . . . . . . . . . . . . . Page 13
dPerfect() Usage . . . . . . . . . . . . . . . . . . . . . . Page 13
Sample Clipper Program (dP_CLIPP.PRG). . . . . . . . . . . . Page 14
DEFINITION OF SHAREWARE . . . . . . . . . . . . . . . . . . . . . Page 15
DISCLAIMER - AGREEMENT . . . . . . . . . . . . . . . . . . . Page 15
TO REGISTER YOUR COPY OF dPERFECT MERGE . . . . . . . . . . . . . Page 16
INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 17
Page iii dPerfect Merge
Convert data base files to Word Perfect secondary merge files
To start the program enter dPERFECT at the DOS command line. If you are
using a trial version, press any key to pass the registration screen (or
you will pause for 3 seconds). Answer each question followed by [Enter].
To move between fields, use [Up arrow] and [Down arrow]. To proceed without
answering additional questions, use [F10] to continue. To exit to the menu
at any time, use [Esc]. To clear a response field, use [Ctrl-Y]. To select
a file from a directory listing, use [F2]. To select a field name from a
field list, use [F4].
CREATE MERGE FILE
"Enter path and filename of source data base file:"
This is the source data base which will be read and
converted to a Word Perfect secondary merge file. This can
be any valid dBase III Plus, Clipper, Foxbase, Foxpro or
compatible data base. Pathnames are required if your data
base is not in the current directory. The ".DBF" extension
is optional. If you enter a filename that doesn't exist or
is not a valid data base, you will get an error message.
This is a required field.
To view a directory listing use [F2]. Enter the directory
path you wish to view, including a DOS file skeleton using
the wildcard characters "?" or "*". To view all files use
the "*.*" skeleton. To view a listing of the current
directory, just press [Enter]. To scroll through the
directory listing use [Up arrow], [Down arrow], [Home] and
[End]. To select a file, use [Enter]. To exit from the
directory listing without selecting a file, use [Esc].
"Enter key expression to create index:"
This is an optional field. If you wish to dynamically
create an index for your data base, enter a single field
name or a compound key expression (e.g. STATE+CITY). Your
merge file will be sorted on this expression. For example,
to create mailing labels in zip code order, enter the zip
code field name from your data base. If you enter an
invalid expression or field name, you will not exit from
this field. Memo and logical fields are not allowed. To
skip this question, press [Enter]. For more examples, see
"Key Index Expressions" on Page 10.
The index created is erased before exiting the program. To
select a field from a list of field names, use [F4]. To
scroll through the list use [Up arrow], [Down arrow], [Home]
and [End]. To select a field name from the list, use
[Enter]. To exit the list without selecting a field, use
[Esc].
"OR enter path and filename of existing index:"
This is an optional field. If you wish to sort your merge
file on an existing dBase III compatible index, enter the
Page 1name of the index. You do not need to include the ".NDX"
extension. If you enter a filename that does not exist, you will
not exit this field. If you enter a filename that is not a valid
index, you will receive an error message. You cannot enter both
an index filename and a key expression to be indexed.
To view a directory listing use [F2]. Enter the directory
path you wish to view, including a DOS file skeleton using
the wildcard characters "?" or "*". To view all files use
the "*.*" skeleton. To view a listing of the current
directory, just press [Enter]. To scroll through the
directory listing use [Up arrow], [Down arrow], [Home] and
[End]. To select a file, use [Enter]. To exit the
directory listing without selecting a file, use [Esc].
"Enter path and filename of Word Perfect secondary merge file to be
created:"
This is the name of the file to be created and is a required
field. If the file exists, you will be prompted with a
warning message. The file extension is optional. If you do
not specify an extension, ".SF" is used. The merge file is
created in Word Perfect 5.1 format unless your configuration
file specifies otherwise. For information on changing to
older versions of Word Perfect, see "Change dPerfect Merge
Configuration" on Page 4. For more information on using
this file to create merge letters, see "Using Word Perfect
Merge Files" on Page 7.
"Enter record selection criteria:"
This is an optional field. You may enter any valid dBase or
Clipper logical expression (up to 79 characters in length).
For example, you can use record selection to only convert
records for clients whose balance is greater than zero, or
only prospects from Tennessee. This is an advanced feature.
If you enter an illegal expression, you will receive an
error message. (See "Record Selection Criteria" on Page 11
for examples and legal operators). Records that are
deleted, will not appear in the merge file. To skip this
field, just press [Enter] and each record in your source
data base file will be converted to a record in the merge
file.
To assist in creating your expression, you can use [F4] to
select from a list of field names. To scroll through the
list use [Up arrow], [Down arrow], [Home] and [End]. To
select from the list, use [Enter]. To exit without
selecting a field, use [Esc].
"There are ___ records that meet your criteria.
Do you wish to re-enter the criteria? [Y/N]"
To continue with the conversion, enter [N] or [F10]. If the
number of records doesn't seem correct, enter [Y] and verify
your responses and your record selection criteria. Deleted
data base records are NOT processed.
Page 2
"Mark fields to be included with the PLUS key:"
Field names from your data base will be displayed. To
include a field in your Word Perfect merge file, use [+],
otherwise use [Space], [Enter], [Up arrow] or [Down arrow].
You must mark at least one field. Memo fields are not
supported and will not appear in the field list or the merge
file. The default format for date fields is MM/DD/YY format
(e.g. 04/30/90). Logical fields are converted to "Y" or
"N". To change the format of either dates or logical values,
see "Change dPerfect Merge Configuration" on Page 4.
To include all your database fields in the merge file, use
[F5] Include all fields. To navigate between screens of
field names, use [Page up] and [Page down]. When you are
finished with your field selection, use [F10] Continue.
"Want to save these parameters as a setup file? [Y/N]"
If you want to re-use these responses to create a merge file
at another time, (or to use with dPerfect BV) enter [Y].
You will then be prompted for the name of the setup file.
Do NOT use an extension for the setup file -- dPerfect will
save the file with the extension ".MEM". You will be warned
if the setup file already exists. A setup file will save
ALL of your responses including:
1) Source data base file name
2) Expression to create index
3) File name of existing index
4) Word Perfect merge file name
5) Record selection criteria
6) Field selection
A setup file, however, does NOT save any of the parameters
included in the configuration file. To use the setup file,
see "Using Setup Files" on Page 7. A setup file is required
to use the batch version dPerfect BV (see Batch Version of
dPerfect Merge on Page 12).
"Do you want to print a summary sheet? [Y/N]"
A summary sheet will detail all of your responses and list
each field that you included along with its Word Perfect
field name. The Word Perfect 5.1 field names are {FIELD}1~,
{FIELD}2~, etc. The older versions of Word Perfect use
field names ^F1^,^F2^ etc. The summary sheet is a useful
tool for creating your Word Perfect primary merge file. It
is printed to DOS port LPT1.
In a Word Perfect 5.1 primary merge file, you can use either
the numeric field names (e.g. {FIELD}1~), or your
alphanumeric data base field names (e.g. {FIELD}zipcode~).
Since WP 5.1 allows a maximum of 100 alphanumeric field
names, you can mix the use of both styles in your primary
merge file. For example, if your dPerfect merge file has
200 field names, you can use your data base field names for
the first 100 fields, and the numeric field names for the
remaining fields.
Page 3CHANGE dPERFECT MERGE CONFIGURATION
To exit from the configuration screen without saving your changes, use
[Esc] at any time. To save your changes use [F10], or answer "Y" to "Save
Configuration". To return all values to the defaults, use [F5] followed by
[F10].
Default Configuration Parameters
Word Perfect version: (1) WP 5.1
Date format: (1) MM/DD/YY
Temporary delimiter: (1) tilde (~)
Logical values: (1) Y/N
Color monitor: (1) Allow automatic detection of color
monitor
European character set: (1) Do not convert
"Word Perfect version:"
dPerfect Merge will create a 5.1 compatible merge file,
unless the version parameter is set to (2) WP 5.0 or (3) WP
4.2. When you first retrieve the merge file in 5.0 or 5.1,
Word Perfect will reformat for your default printer.
In a Word Perfect 5.1 primary merge file, you can use either
the numeric field names (e.g. {FIELD}1~), or your
alphanumeric data base field names (e.g. {FIELD}zipcode~).
Since WP 5.1 allows a maximum of 100 alphanumeric field
names, you can mix the use of both numeric and alphanumeric
field names. For example, if your dPerfect merge file has
200 field names, you can use your data base field names for
the first 100 fields, and the numeric field names for the
remaining fields.
"Date format:"
The default date format is "03/30/90". To change to
European format (e.g. "30/03/90") use option (2) DD/MM/YY.
For dates like "March 30, 1990" use option (3) Month DD,
YYYY.
"Temporary delimiter:"
dPerfect Merge uses a temporary delimiter to create the
merge files. The default is the tilde (~) character. If
your data base includes the use of the tilde, choose a
delimiter that is NOT in your data. Options are the carat
(^) and the horizontal bar (|).
"Logical values:"
Logical values are converted to "Y" or "N" unless you
specify (2) YES/NO or (3) Yes/No or (4) yes/no.
"Color monitor:"
dPerfect Merge will automatically detect whether your monitor is
color or monochrome. Some "color" monitors, however, only
Page 4display colors as shades of gray -- making it very difficult
to view the dPerfect Merge screens in color mode. For these
systems, choose (2) Force use of monochrome (useful for
laptops). Your new color choice will not take effect until
the next time you use dPerfect Merge.
"European character set:"
dPerfect Merge will convert the high Ascii characters from
decimal 128 to 175, if you choose (2) Convert. These are
European characters, such as umlauts and accents. For a
faster conversion, choose (1) Do not convert.
Use of the Configuration File
dPerfect Merge uses dPERF$$$.DBF to save configuration
parameters and to coordinate the naming of temporary files
for multiple users. This file must be in the DOS path. If
multiple users on a network are not all using the same
configuration (e.g. different version of Word Perfect), each
user must have his own copy of dPERF$$$.DBF in his path. If
the configuration data base is erased or becomes corrupted,
restore it from your original distribution disk.
Page 5
REGISTRATION INFO
When you register your copy of dPerfect Merge (along with the latest
version of dPerfect Merge, a printed manual and 90 days of support) you
will receive a registration key. Input this key number along with your
registration name to bypass the initial registration screen. After you
have entered your registration info, your registration name will appear on
the initial menu screen.
For pricing and an order form, see Page 16. For more information, you can
contact me:
Newdorf Research
P.O. Box 2309
Rancho Santa Fe, CA 92067
Barbara J. Feldman
CompuServe ID: 73170,216
VOICE: (619) 942-0688 (ask for Barbara)
FAX: (619) 942-9387
"Name of Registered Owner:"
Enter your registration name (either an individual or a
company name) exactly as shown on your registration letter.
"Registration Key:"
Enter the registration key that is provided in your
registration letter. You will not exit this field unless
you have a valid registration key. To exit without a
registration key, leave the field empty.
CompuServe Offer
FREE!! -- when you register, you are entitled to a free
introductory subscription to CompuServe Information Service,
the biggest national on-line information data base and
service. You will receive a private user ID number and
password, a $15 usage credit (up to 2 1/2 hours connect time
at 300 baud), and a complimentary subscription to
CompuServe's monthly magazine.
Page 6
USING dPERFECT MERGE
Help Screens
Context-sensitive help screens are available from almost
every input field, by use of [F1]. Press any key to exit
from the help screen.
Using Setup Files
To use a setup file, enter it as a / parameter to dPerfect
on the DOS command line. For example, to use setup file
ALLZIPS.MEM, start the program with:
dPERFECT /allzips
You will be given the opportunity to change any of your
responses. To continue without any changes, press [F10]
three times. A setup file will save ALL of your responses
including:
1) Source data base file name
2) Expression name to create index
3) File name of existing index
4) Word Perfect merge file name
5) Record selection criteria
6) Field selection
A setup file will not save the configuration parameters
(such as Word Perfect version, or data format). Setup files
may be used with the interactive version (dPERFECT.EXE) but
are required with the batch version (dPERFBV.EXE). They can
not be used with the Clipper function version
(dPERFECT.OBJ). For more information on creating setup
files, see "Want to save this parameters as a setup file?"
on Page 3.
Versions of Word Perfect Supported
The default Word Perfect version is 5.1. To create a 5.0 or
4.2 compatible merge file, change the dPerfect Merge
configuration (from the main menu). Word Perfect 5.1 merge
files include data base field names -- allowing you to
create primary merge files using your data base field names.
Word Perfect 5.1 allows a maximum of 100 alphanumeric field
names. Additional fields can be accessed by their numeric
field name (e.g. {FIELD}101~). For more information, see
your Word Perfect reference manual.
Using Word Perfect Merge Files
dPerfect creates a Word Perfect secondary merge file. The
secondary file is the list of variable data (such as names,
addresses, phone numbers) that is merged with your fixed
data (primary file) to create form letters, mailing labels,
etc. To create the primary merge file (the actual form
letter, or mailing label format), use Word Perfect. Insert
?merge codes for each variable field [Shift-F9], using either
the numeric or alphanumeric (WP 5.1 only) field name. Using
a printed summary sheet from dPerfect Merge, will make it
easier to remember the field names and numbers.
To begin the merge from within Word Perfect, use [Ctrl F9]
[Merge] and name your secondary and primary files. For
additional information, see your Word Perfect reference
manual. Uses for dPerfect Merge include mailing labels,
personalized form letters, data base publishing,
directories, and lists.
Network Capabilities of dPerfect Merge
dPerfect Merge will operate in a network environment
allowing multiple users to access common data bases using
record locking. If your source data base is unavailable for
shared use, you will be given the opportunity to either
retry or exit. The configuration file dPERF$$$.DBF must be
located in the DOS path. This file is used to coordinate
the naming of temporary files among multiple users, and
stores the configuration parameters. If individual users
need to have different dPerfect Configuration parameters,
place dPERF$$$.DBF on a local or private drive. dPerfect
Merge requires Read/Write/Create/Delete privileges in the
current directory so that it may create and delete its
temporary files.
Use of the Tilde (~) Character
WARNING!! If your data contains the tilde (~) character,
dPerfect Merge MAY have trouble converting your data
correctly because the tilde is used as a temporary
delimiting character during the conversion. To resolve any
conflicts, change the delimiter character on the
configuration screen.
Working Disk Space Required
dPerfect Merge requires approximately twice the space of the
merge file you wish to create. For example, if your data
base is 10 MB in length and you are converting 30% of your
records to a merge file, dPerfect will require 3 MB in
temporary disk space and 3 MB for your merge file --
totaling 6 MB.
Temporary Working Files
dPerfect Merge creates and erases a variety of temporary
working files. If the program is interrupted by a power
failure, or the system is rebooted while dPerfect is
running, the temporary files will NOT be erased. The
temporary files are created in the current directory, and
are named "DP$$$xxx.*" where xxx is a number from "000"
through "999".
Page 8
Minimum DOS Configuration Required
dPerfect Merge requires DOS 3.1 or greater and 512Kb memory.
dPerfect Merge works on dBase III Plus, Clipper, FoxPro,
FoxBase or compatible data bases and supports "ndx" index
files. Clipper "ntx" index files are supported by the
Clipper (S'87) function dPerfect() in dPERFECT.OBJ.
dPerfect supports up to 1024 fields per data base and 510
selected fields per merge. dPerfect creates secondary merge
files for either Word Perfect 5.1, 5.0 or 4.2. CONFIG.SYS
must contain "Files=10" or greater. For more information on
CONFIG.SYS, consult your DOS manual.
The configuration file dPERF$$$.DBF must be located in the
DOS path. This file is used to coordinate the naming of
temporary files among multiple users, and stores the
configuration and registration parameters. If individual
users on a network need to have different dPerfect
Configuration parameters, place dPERF$$$.DBF on a local or
private drive.
Page 9Index Key Expressions
Data
Operator Type Meaning Example
---------------------------------------------------------------------------
-
+ C Concatenation STATE+CITY
+ N Addition TAX+AMOUNT
+ D+N Adds days to date ORDER_DATE+AR_AGE
- D-N Subtracts days from date CLOSE_DATE-LEN_ESCRW
- D-D Elapsed days between dates SALE_DATE-LIST_DATE
DTOS() D Convert date to character DTOS(SALE_DATE)
STR() N Convert numeric to character STR(NUMBER)
VAL() C Convert character to numeric VAL(CHAR_AMT)
Be sure to consider the data type of your fields when creating a key index
expression. Use DTOS(date_field) to convert dates to character type
suitable for indexing. To create multiple level sorts, use concatenation.
For example, to sort by state, followed by city, followed by sold date,
followed by last name and first name:
STATE+CITY+DTOS(SOLD_DATE)+LAST_NAME+FIRST_NAME
Page 10
Record Selection Criteria
Data Record Selection
Operator Type Meaning Example
-------------------------------------------------------------------------
= C,N,D Equal to ZIPCODE="92561"
<> or # C,N,D Not equal to STATE <> "TX"
> C,N,D Greater than AMOUNT > 100
< C,N,D Less than AMOUNT < 100
>= C,N,D Greater than or equal to AMOUNT >= 100
<= C,N,D Less than or equal to AMOUNT <= 100
$ C Contained within PROD_TYPE $"1234"
.AND. L True if both expressions STATE="TX" .AND.
are true AMOUNT>100
.OR. L True if either expression STATE="TX" .OR.
is true AMOUNT>100
.NOT. L True if expression is false .NOT. STATE = "TX"
+ N Addition AMOUNT+TAX > 1000
+ C Concatenation FIRST+LAST="JOHNSMITH"
+ D+N Adds days to date ORDER_DATE+10 < DATE()
- N Subtraction GROSS-NET>10000
- D-N Subtracts days from date SHIP_DATE-10 <=
ORDER_DATE
- D-D Elapsed time between dates SHIP_DATE-ORDER_DATE > 10
* N Multiplication AMOUNT*TAX_RATE > 1000
/ N Division TOT_AMT/AVG_PRICE > 10
Record selection criteria must be logical expressions -- expressions that
evaluate to either .T. (true) or .F. (false). In addition to the operators
listed above, any valid Clipper function may be used (e.g. !EMPTY(AMOUNT))
Be sure to use consider the data type of the fields that you are selecting.
The contents of data fields must be enclosed in quotes. For example, if
ZIPCODE is a character field:
ZIPCODE = 90304 Not a valid expression
ZIPCODE = "90304" Is a valid expression
Page 11
BATCH VERSION OF dPERFECT MERGE
The Batch Version of dPerfect Merge allows batch processing of your
conversion, and does not require any keyboard input. dPERFECT BV uses a
setup file to specify all the input parameters. It is designed to be called
from a DOS batch file, from a DOS menu or from any program that can run
external .EXE files. It allows a programmer to integrate dPerfect Merge
into a customized system, without training the end-user on dPerfect Merge.
dPERFBV will clear the screen before executing, and restore the original
screen upon exit.
Using the Batch Version of dPerfect (dPERFBV.EXE)
To create a setup file for dPerfect BV, first use the
interactive version (dPERFECT.EXE) and save your input as a
setup file. After the setup file has been saved, call
dPERFBV from the DOS command line or in a batch file.
Remember, the setup file is a required parameter. For
example:
dPERFBV /setup
dPerfect BV sets the DOS ERRORLEVEL as follows:
ERRORLEVEL = 1 Successful completion
ERRORLEVEL = 2 Fatal error
If there is an error, the user is warned as to the type of
error -- and is prompted to "Press Return To Continue".
This is the only user input that is required. When there is
a successful completion, the user is returned to the calling
program (without requiring any user keystrokes).
WARNING: dPerfect BV does NOT warn before writing over an existing merge
file.
Sample Batch File (dP_BTEST.BAT):
ECHO OFF
CLS
ECHO This batch file assumes a setup file named "TEST"
ECHO otherwise, the merge file will not be generated.
PAUSE
dperfbv /test
CLS
IF ERRORLEVEL 2 GOTO no_wp
ECHO Creation of merge file successful!
ECHO Word Perfect can be started with a macro that
ECHO will do the merge. The following assumes that
ECHO the macro is named "MERGE".
PAUSE
wp /m-merge
GOTO end
:no_wp
ECHO An error prevented the creation of the merge
file.
PAUSE
:end
Page 12CLIPPER FUNCTION dPERFECT()
For Clipper (Summer '87) programmers, dPerfect() is provided as an .OBJ
object file to include in your linkage.
dPerfect() Syntax
dPerfect("MERGE.SF", ARRAY)
dPerfect() Arguments
"MERGE.SF" is the filename of the merge file to be created -
- be sure to include it in quotes.
ARRAY is the field selection array, indicating which fields
are to be included in the merge file. For a field to be
included, the corresponding array element must be "+". Any
other value, and the field will not be included in the merge
file. The ARRAY parameter is optional. If it is not
specified, all fields will be included in the merge file.
See the example below.
dPerfect() Return Value
dPerfect() returns the number of records that are translated
to the merge file, as well as setting the DOS errorlevel as
follows:
ERRORLEVEL () = 1 Successful completion
ERRORLEVEL () = 2 No merge file was specified
ERRORLEVEL () = 3 Configuration record busy
ERRORLEVEL () = 4 No records in source data base
ERRORLEVEL () = 5 No fields included in selection array
ERRORLEVEL () = 6 Temporary file busy
ERRORLEVEL () = 7 Cannot open/write/close merge file
dPerfect() Usage
Before calling the dPerfect() function, a data base must be
selected. Any indices or filters that are in use will be
reflected in the merge file. This provides for the use of
.NTX index files which are not supported in the interactive
(dPERFECT.EXE) or batch (dPERFBV.EXE) versions of dPerfect
Merge. SET DELETED ON/OFF will affect whether deleted
records are processed.
If "merge.sf" exists, it will be rewritten without warning.
There is no error trapping included in dPerfect(). Fatal
errors will be handled by Clipper (for example, if you are
out of disk space). Other errors will result in an
ERRORLEVEL() > 1. Upon exiting dPerfect(), your source data
base will be selected and the record pointer will be at TOP.
The screen and its original colors will be restored, the
cursor will be on and DATE will be set to either AMERICAN or
BRITISH (depending on the setting of your configuration file
dPERF$$$.DBF). This configuration file must be in the DOS
path. There is no user input required at any time during
the execution of dPerfect().
Page 13Sample Clipper Program (dP_CLIPP.PRG):
* This assumes a database named "database",
* an index named "data_ntx", and a
* filter expression named "data_filtr"
SELECT A
USE database && select your data base
SET INDEX TO data_ntx && optional index
SET FILTER TO &data_filtr && optional filter
DECLARE array[FCOUNT()] && create optional array
AFILL (array,"+") && fill with pluses
array[1] = SPACE(1) && DO NOT translate 1st field
count = dPerfect("merge.sf",array) && create "merge.sf"
IF ERRORLEVEL() = 1 && successful completion
? STR(count) && display # records
ELSE
? "Sorry -- dPerfect Error!" && error occurred
ENDI
Page 14
DEFINITION OF SHAREWARE
Shareware distribution gives users a chance to try software before buying
it. If you try a Shareware program and continue using it, you are expected
to register. Copyright laws apply to both Shareware and commercial
software, and the copyright holder retains all rights, with a few specific
exceptions as stated below. Shareware authors are accomplished
programmers, just like commercial authors, and the programs are of
comparable quality. (In both cases, there are good programs and bad ones!)
The main difference is in the method of distribution. Shareware is a
distribution method, not a type of software. You should find software that
suits your needs and pocketbook, whether it's commercial or Shareware. The
Shareware system makes fitting your needs easier, because you can try
before you buy. And because the overhead is low, prices are low also.
Shareware has the ultimate money-back guarantee -- if you don't use the
product, you don't pay for it.
DISCLAIMER - AGREEMENT
Users of dPerfect Merge must accept this disclaimer of warranty: "dPerfect
Merge is supplied as is. The author disclaims all warranties, expressed or
implied, including, without limitation, the warranties of merchantability
and of fitness for any purpose. The author assumes no liability for
damages, direct or consequential, which may result from the use of dPerfect
Merge."
dPerfect Merge is a "shareware program" and is provided at no charge to the
user for evaluation. Feel free to share the self-extracting archive file
with your friends, but please do not give it away altered or as part of
another system. The essence of "user-supported" software is to provide
personal computer users with quality software without high prices, and yet
to provide incentive for programmers to continue to develop new products.
If you find this program useful and find that you are using dPerfect Merge
and continue to use dPerfect Merge after a 30 day trial period, you must
make a registration payment of $27 to Newdorf Research. The $27
registration fee will license one copy for use on any one computer at any
one time.
Commercial users of dPerfect Merge must register and pay for their copies
of dPerfect Merge within 30 days of first use or their license is
withdrawn. Site-License arrangements may be made by contacting Newdorf
Research. Anyone distributing dPerfect Merge for any kind of remuneration
must first contact Newdorf Research at the address below for authorization.
This authorization will be automatically granted to distributors recognized
by the (ASP) as adhering to its guidelines for shareware distributors, and
such distributors may begin offering dPerfect Merge immediately. (However
Newdorf Research must still be advised so that the distributor can be kept
up-to-date with the latest version of dPerfect Merge.)
You are encouraged to pass a copy of dPerfect Merge along to your friends
for evaluation. Please distribute the self-extracting archive file (rather
than individual files) and encourage them to register their copy if they
find it useful. All registered users will receive a copy of the latest
version of dPerfect Merge, a printed manual and a registration key that
will bypass the initial registration screen.
Page 15
TO REGISTER YOUR COPY OF dPERFECT MERGE
Receive the latest version of dPerfect Merge, a printed manual, 90 days of
support via phone, fax, mail or CompuServe -- AND you are entitled to a
free introductory CompuServe subscription and $15 usage credit.
NOTE: Your registered copies of dPerfect Merge will not display the
registration screen.
Site-License arrangements may be made by contacting Newdorf Research.
Pricing Pricing
Qty: 5 1/4" disk: 3 1/2" disk:
1-10 $24 + Shipping $25 + Shipping
Disk Size: [ ] 5 1/4" [ ] 3 1/2"
Quantity:_________ X Price: $_____________ $________
California Sales Tax (7.75%) $_________
Shipping/Handling QTY: ______ X $______ $_________
[ ] U.S. $3.00 each
[ ] Mexico/Canada $4.00 each
[ ] Other Foreign $7.00 each
Total Enclosed $_________
Send check or money order (in US funds drawn on US bank, please) to:
Newdorf Research
P.O. Box 2309
Rancho Santa Fe, CA 92067
Name of Registered Owner:_________________________________________
(list name or company exactly as you wish it to appear on the screen)
Contact Person:___________________________________________________
Company:__________________________________________________________
Address:___________________________________________________________
City:________________________________ State:_________Zip:__________
Phone: (______)___________________CompuServe User ID:______________
Where did you get your copy of dPerfect Merge?_____________________
Comments and Suggestions:__________________________________________
___________________________________________________________________
Page 16
INDEX
ASP . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page i, Page 15
Batch Processing. . . . . . . . . . . . . . . . . . . . . . . . . . Page 12
Carat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
Clipper . . . . . . . . . . . . . . . . . . . . . . . . . . Page 1, Page 13
Summer '87 . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13
Color monitors. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
CompuServe. . . . . . . . . . . . . . . . . . . . . . . . . .Page i, Page 6
CONFIG.SYS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 9
Configuration . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 7
Defaults . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
File . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5, Page 8
Control Keys
[Ctrl-Y] . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
[Esc]. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
[F10]. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
[F2] . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1, Page 2
[F4] . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
[F5] . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3, Page 4
Create Merge File . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
Dates
European . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
Formats. . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
dBase III Plus. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
Deleted records . . . . . . . . . . . . . . . . . . . . . . Page 2, Page 13
Delimiter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
Carat. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
Horizontal bar . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
Tilde. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
Directory Listing . . . . . . . . . . . . . . . . . . . . . .Page 1, Page 2
Disk Space Required . . . . . . . . . . . . . . . . . . . . . . . . .Page 8
DOS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 9
dP_BTEST.BAT. . . . . . . . . . . . . . . . . . . . . . . . Page i, Page 12
dP_CLIPP.PRG. . . . . . . . . . . . . . . . . . . . . . . . Page i, Page 14
dP_READ.ME. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page i
dPERF.EXE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page i
dPERF$$$.DBF. . . . . . . . . . . . . . . . . . . . .Page 5, Page 8, Page 9
dPERFBV.EXE . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 12
dPERFECT.OBJ. . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13
DPerfect(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13
Errorlevels . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 12
European characters . . . . . . . . . . . . . . . . . . . . . . . . .Page 5
Expressions, logical. . . . . . . . . . . . . . . . . . . . . . . . Page 11
Field names . . . . . . . . . . . . . . . . . . . . .Page 3, Page 4, Page 7
Fields. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
Date . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3, Page 4
Field names. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
Logical. . . . . . . . . . . . . . . . . . . . .Page 1, Page 3, Page 4
Memo . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1, Page 3
Page 17
Filename Extensions. . . . . . . . . . . . . . . . . . . . . . . . .Page 2
.DBF . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
.MEM . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
.NDX . . . . . . . . . . . . . . . . . . . . . . . . . .Page 2, Page 9
.SF. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 2
Filenames . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page i
Filters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13
Help screens. . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 7
Horizontal Bar. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 1, Page 13
Index Expression. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
Key Expression. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
Logical Expressions . . . . . . . . . . . . . . . . . . . . . . . . Page 11
LPT1. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
Monochrome monitors . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
Networks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 8
Operators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 11
Print . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
Record Selection. . . . . . . . . . . . . . . . . . . . . . Page 2, Page 11
Register dPerfect Merge . . . . . . . . . . . . . . . . . . . . . . Page 16
Registration key. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6
Save Setup File . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
Selection Criteria. . . . . . . . . . . . . . . . . . . . . . . . . .Page 2
Setup File. . . . . . . . . . . . . . . . . . . . . Page 3, Page 7, Page 12
Shareware . . . . . . . . . . . . . . . . . . . . . . . . . Page i, Page 15
Sort. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
Source data base. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
Summary Sheet . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
Support . . . . . . . . . . . . . . . . . . . . . . . . . . Page i, Page 16
Temporary working files . . . . . . . . . . . . . . . . . . . . . . .Page 8
Tilde . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 8
Warranty. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 15
Word Perfect
4.2. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 2, Page 4
5.0. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 2, Page 4
5.1. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 2, Page 4
Field Names. . . . . . . . . . . . . . . . . . . . . . .Page 3, Page 4
Primary merge file . . . . . . . . . . . . . . . . . . . . . . .Page 3
Secondary merge file . . . . . . . . . . . . . . . . . .Page 2, Page 7
Versions . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 7
Page 18